insert overwrite table jms_dim.dim_tab_rou_competitor_effective
select
sender_province
,sender_province_id
,sender_city
,sender_city_id
,receiver_province
,receiver_province_id
,receiver_city
,receiver_city_id
,times
,platform
,platform_code
,create_time
,modify_time
,create_by
,create_by_id
,id
from jms_ods.tab_rou_competitor_effective where dt = '{{ execution_date | cst_ds }}'
 distribute by 1 ;